ASP搜索功能`` 请大鸟指点下

来源：百度知道 编辑：UC知道 时间：2024/06/24 11:46:41
untitled.asp 代码

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="form1" method="post" action="type.asp">
<tr>
<td width="100%" height="22"><div align="center" class="song"></div>
<div align="center">

type.asp 代码

<!--#include file="conn.asp"-->
<%
dim maxperpage,curpage,i,rank,keyy,invert
keyy=request("key")
maxperpage=20 '显示新闻条数
typeid=trim(request("type"))
if typeid="title" then '按文章标题查找
set rs=server.createobject("adodb.recordset")
rs.open "select * from news where title like '%" & key & "%' order by time DESC",conn,1,1
rank="新闻名称"
end if
if typeid=&

keyy=request("key")

rs.open "select * from news where title like '%" & key & "%' order by time DESC",conn,1,1

rs.open "select * from news where content like '%" & key & "%' order by time DESC",conn,1,1

sql语句里的key是没有值的,应该是keyy吧

....
set rs=server.createobject("adodb.recordset")
if typeid="title" then '按文章标题查找
sql="select * from news where title like '%" & key & "%' order by time DESC"
rank="新闻名称"
end if
if typeid="content" then '按文章标题查找
sql="select * from news where content like '%" & key & "%' order by time DESC"
rank="新闻内容"
end if
rs.open sql,conn,1,1
....
...